01 Executive Scorecard
Market Share
18.9%
Forecast 19.0% | 99.5% accurate
Revenue
$3,708K
+1.5% vs Q2 | Forecast $3,792K
Net Income
$241K
Planned dip | Forecast $248K
Units Sold
332K
Forecast 341K | Seasonal Q3
Bonds
$1,000K
Was $1,500K | Saved $75K/qtr interest
Interest Coverage
22.6x
#1 in the world | Altman Z: 2.42
Why NI dipped: 46hr overtime cost + Area 2 Q3/F3 lock (~$28K) + bond callback premium ($25K). All planned — not a concern.
02 Forecast Model Accuracy
| Metric | Forecast | Actual | Variance | Accuracy |
|---|
| Market Share | 19.0% | 18.9% | −0.1pp | 99.5% |
| Total Units | 341K | 332K | −9K | 97.4% |
| Revenue | $3,792K | $3,708K | −$84K | 97.8% |
| Net Income | $248K | $241K | −$7K | 97.2% |
| EPS | $0.041 | $0.040 | −$0.001 | 97.6% |
| Bonds | $1,000K | $1,000K | Exact | 100% |
Sales by Area — Forecast vs Actual
| Area | Forecast | Actual | Diff | Note |
|---|
| Area 1 | 94K | 88K | −6K | Gordon surge absorbed demand |
| Area 2 (Home) 🏠 | 105K | 110K | +5K | Home advantage outperformed |
| Area 3 | 93K | 87K | −6K | Gordon/SJSU pressure |
| Nystok | 48K | 47K | −1K | Near perfect |
| Total | 340K | 332K | −8K | Gordon's unexpected surge to 24% |
03 Financial Summary
Income Trend
| Item | Q2 | Q3 |
|---|
| Revenue | $3,652K | $3,708K |
| Net Income | $265K | $241K |
| Bond Interest | $38K | $25K ↓ |
| EPS | $0.044 | $0.040 |
| Stock Price | $1.12 | $1.17 ↑ |
Balance Sheet
| Item | Q2 | Q3 |
|---|
| Cash | $1,329K | $1,211K |
| Timed CDs | $2,200K | $1,300K |
| Total Liquid | $3,529K | $2,511K |
| Bonds | $1,500K | $1,000K ↓ |
| Total Equity | $12,143K | $12,390K ↑ |
Cash Flow — Q3
Beginning Cash$1,329K
Prior AR collected+$1,892K
Current sales collected+$1,830K
Production + operating + taxes paid−$3,241K
Net Operating CF+$481K
CDs matured ($2,200K) − reinvested ($1,300K)+$900K
Nystok plant payment (1 of 3)−$867K
Net Investing CF+$51K
Bond callback $500K + 5% premium−$525K
Bond interest−$38K
Net Financing CF−$563K
ENDING CASH~$1,211K (+$1,300K CDs = $2,511K liquid)
04 Competitor Analysis — World 1
| Company | Units | Share | Revenue | NI | A1 Price | A2 Price | A3 Price | Nystok | Model |
|---|
| 🐝 Hornet (Us) | 332K | 18.9% | $3,708K | $241K |
$10.70 | $10.80 | $10.70 | Dn 82 | Model 2 |
| AttiPals (Co1) | 319K | 18.2% | $3,300K | $260K |
$10.00 | $10.00 | $10.00 | Dn 72 | Model 1 |
| Gordon (Co3) ⚠️ | 420K | 24.0% | $4,133K | $223K |
$9.60 | $9.50 | $9.40 | Dn 75 | Model 2 |
| SJSU (Co4) | 372K | 21.2% | $3,574K | $85K |
$9.30 | $9.30 | $9.30 | Dn 69 | Model 1 |
| CSUN (Co5) | 309K | 17.6% | $3,213K | $109K |
$10.00 | $10.00 | $10.00 | Dn 74 | Model 1 |
Gordon also launched Model 2 — priced aggressively at $9.40–$9.60 (Q1/F2 in Area 2, Q1/F1 in Nystok). We are both on Model 2 but positioned differently: Hornet = premium quality ($10.70+) vs Gordon = volume/low price ($9.40–$9.60). Gordon's surge to 24% share directly caused our Area 1 & 3 miss.
Financial Health
| Company | NI | Bonds | Bonds/Equity | Interest Coverage | Stock Price |
|---|
| 🐝 Hornet | $241K | $1,000K | 8.1% | 22.6x | $1.17 |
| AttiPals | $260K | $2,000K | 16.0% | 12.4x | $1.17 |
| Gordon | $223K | $4,000K | 32.6% | 8.4x | $1.16 |
| CSUN | $109K | $2,000K | 16.6% | 8.2x | $1.14 |
| SJSU | $85K | $5,000K + $500K loan | 42.2% | 4.4x | $1.11 |
Competitor Profiles
AttiPals — Co1
Threat: Medium
Share: 18.2% ↓
NI: $260K (best Q3)
Cash: $4,510K (very rich)
Model: 1
- Most cash-rich company — $3,510K cash + $1,000K CDs
- Conservative strategy, no expansion, no model upgrade yet
- Risk: could launch Model 2 with their war chest any time
- Share declining — may be preparing an offensive move
Gordon College — Co3
Threat: HIGH
Share: 24.0% ↑ from 21.1%
Units: 420K (+30K vs Q2)
Bonds: $4,000K
Fixed Assets: $12,829K (#1 world)
Model 2: Q1/F2 (A2), Q1/F1 (N)
- Launched Model 2 at $9.40–$9.60 — volume strategy, not premium
- Sold 88K more units than us but earned $18K less NI — thin margins
- Debt-funded growth: bonds/equity at 32.6%, coverage 8.4x
- Biggest Q3 winner — their surge explains our A1 & A3 shortfall
- Q1/F2 in Area 2, Q1/F1 in Nystok — lower quality than our Q2/F2
San Jose State — Co4
Threat: Medium
Share: 21.2% ↓ from 23.1%
NI: $85K (lowest)
Debt: $5,500K
Coverage: 4.4x
- Most over-leveraged — $5,000K bonds + $500K bank loan (red flag)
- Share falling despite massive investment — low-price strategy not working
- Financial fragility: if demand softens, could face distress
- Large cash balance ($4,782K) suggests major bond issue this quarter
CSUN — Co5
Threat: Low
Share: 17.6% ↓ (lowest in world)
NI: $109K
Bonds: $2,000K
- Losing share every quarter — now last place at 17.6%
- Stuck in the middle: not cheap enough vs Gordon/SJSU, not premium enough
- No clear strategic direction — limited threat
05 Macroeconomic Context
| Indicator | Q2 | Q3 | Signal |
|---|
| Merica GDP | 103.0 | 104.9 | Growing — supports Q4 demand |
| Nystok GDP | 104.1 | 107.7 | Booming — plant investment validated |
| Stock Market | 110.8 | 112.9 | Bullish |
| CD Rate | 3.24% | 3.07% | Falling — reinvest CDs soon |
| Our Bond Rate | — | 4.80% | Credit Rating 2 — good for Q4 issue |
06 Q4 Priorities
Q4 is the peak demand quarter — seasonal factor 1.213 = +29% more demand than Q3. We have 194K ending inventory as a head start.
| # | Action | Why |
|---|
| 1 | Run 44–48hr overtime | Need ~480K+ units for peak demand |
| 2 | Issue $1,000K bonds at 4.80% | Fund 2nd plant payment — half the old 10% rate |
| 3 | 2nd Nystok plant payment ($867K) | Keep construction on schedule (Y4Q2 opening) |
| 4 | Increase sales orders all areas | Don't leave demand on the table — peak quarter |
| 5 | Boost ads in Areas 1 & 3 | Counter Gordon's 24% surge |
| 6 | Reinvest $1,300K CDs | Rate falling — lock in 3.07% before it drops |
07 My Contribution — Q3 Decision Making
Sales Forecasting
- Built prediction model forecasting 341K vs actual 332K — 97.4% accurate
- Per-area forecasts within 1–6K across all 4 markets
- Guided team on sales office orders to avoid Q2's stockout mistake
Price Point Strategy
- Tested 210+ scenarios to find optimal price for Model 2 launch
- Recommended $10.70–$10.80 — above Q1 baseline of $10.50
- Result: highest revenue-per-unit in the world ($11.18 vs Gordon $9.84)
Nystok Plant Investment
- Built financial case using Nystok GDP growth (104.1 → 107.7)
- Modeled bond callback strategy — saved ~$300K/yr in interest
- Result: best interest coverage in the world at 22.6x
Analysis Report
- Produced this full quarterly analysis with competitor benchmarking
- Forecast-vs-actual reconciliation to improve future predictions